import pandas as pd
from pyecharts import optinos as opts
from pyecharts.charts import Scatter
df = pd.read_excel('某店铺销售数据.xlsx')
scatter = Scatter(init_opts=opts.InitOpts(page_title='气泡图'))
scatter.add_xaxis(xaxis_data=df['商品价格(元)'])
scatter.add_yaxis(series_name='',y_axis=df[['销售额(元)','利润率(%)']].values.tolist())